
<aside class="main-sidebar">
    <!-- sidebar: style can be found in sidebar.less -->
    <section class="sidebar">
        <ul class="sidebar-menu">
            <li class="header">欢迎</li>
            <li class=" treeview">
                <a href="#">
                    <i class="fa fa-user"></i> <span>用户</span> <i class="fa fa-angle-left pull-right"></i>
                </a>
                <ul class="treeview-menu">
                    <li class=""><a href="index.php?p=pipe_user"><i class="fa fa-circle-o"></i>渠道用户</a></li>
                    <li class=""><a href="index.php?p=admin_user"><i class="fa fa-circle-o"></i>后台用户</a></li>
                </ul>
            </li>
            <li class=" treeview">
                <a href="#">
                    <i class="fa fa-cube"></i> <span>产品</span> <i class="fa fa-angle-left pull-right"></i>
                </a>
                <ul class="treeview-menu">
                    <li class=""><a href="index.php?p=product_mani"><i class="fa fa-circle-o"></i>产品管理</a></li>
                </ul>
            </li>
            <li class="active treeview">
                <a href="#">
                    <i class="fa fa-database"></i> <span>数据</span> <i class="fa fa-angle-left pull-right"></i>
                </a>
                <ul class="treeview-menu">
                    <li class="active"><a href="index.php?p=data_mani"><i class="fa fa-circle-o"></i>列表</a></li>
                </ul>
            </li>
        </ul>
    </section>
    <!-- /.sidebar -->
</aside>
<!-- Main content -->
<div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
        <div class="row">

            <div class="col-xs-6">

                <h1>
                    数据
                    <small>列表</small>
                </h1>
            </div>
        </div>

    </section>
    <section class="content">
        <div class="row">

            <div class="col-md-3 date">
                    <h4>日期选择</h4>
                    <input type="text" id="data-dp" name="dateRange" class="form-control" >
                    <i class="glyphicon glyphicon-calendar fa fa-calendar"></i>
            </div>
            <div class="col-md-3">
                <h4>渠道名称查询</h4>
                <select class="form-control" id="data-search">
                    <option value="all">全部渠道</option>
                    <?php
                        $rows = $mysql->query("select `pipe_name` from `pipe`");
                        foreach($rows as $row){
                            echo "<option value=".$row['pipe_name'].">".$row['pipe_name']."</option>";
                        }
                    ?>
                </select>

                <!--<i class="glyphicon glyphicon-calendar fa fa-search"></i>-->
            </div>
            <div class="col-md-3 col-md-offset-3 ">

                <div class="form-group">
                    <form action="apis/data_excel.php?action=import" method="post" enctype="multipart/form-data">
                        <label for="exampleInputFile"><h4>Excel 导入数据</h4></label>
                        <input type="file" id="exampleInputFile" name="xls-file">
                        <p color="lightgrey">（目前仅限表格以xls格式上传）</p>
                        <button type="submit" name="submit" class="btn">确认</button>
                        <input type="button" class="btn" id="exportCSV" value="导出XLS"></>
                    </form>
                </div>
            </div>

        </div>

        <div class="row">
            <div class="col-xs-12">
                <div class="box">
                    <div class="box-body">
                        <table id="data-tabel" class="table table-bordered table-hover">
                            <thead>
                            <tr>
                                <th>日期</th>
                                <th>产品名称</th>
                                <!--<th>销售代表</th>-->
                                <th>渠道名称</th>
                                <th>新增用户</th>
                                <th>第三方新增用户</th>
                                <th>激活用户</th>
                                <th>激活用户参考</th>
                                <th>渠道类型</th>
                                <th>单价/分成</th>
                                <th>总信息费</th>
                                <th>显示比例</th>
                                <th>显示金额</th>
                                <th>利润</th>
                                <th>利润率</th>
                                <th>提交日期</th>
                                <th>状态</th>
                            </tr>
                            </thead>
                            <tbody id="dateTable">
                            </tbody>
                        </table>
                    </div><!-- /.box-body -->
                </div><!-- /.col -->
            </div><!-- /.row -->
        </div><!-- /.row -->
    </section><!-- /.content -->
</div>